import pandas as pd
data = pd.read_excel('股票信息表.xlsx', sheet_name=0)
print(data)

# 补全股票代码
data['股票代码'] = data['股票代码'].astype(dtype='string')
data['股票代码'] = data['股票代码'].str.zfill(width=6)
print(data)

# 补全网址
data['利润表'] = 'https://data.eastmoney.com' + data['利润表']
print(data)
